Pandas Profiling Report

Dataset statistics

Number of variables	9
Number of observations	5058
Missing cells	0
Missing cells (%)	0.0%
Duplicate rows	0
Duplicate rows (%)	0.0%
Total size in memory	355.8 KiB
Average record size in memory	72.0 B

Variable types

Numeric	9

Alerts

`AUXU500R` is highly overall correlated with `AUXU1K1R` and 1 other fields	High correlation
`AUXU1K1R` is highly overall correlated with `AUXU500R` and 2 other fields	High correlation
`AUXU1K2R` is highly overall correlated with `AUXU500R` and 2 other fields	High correlation
`AUXU2KR` is highly overall correlated with `AUXU1K1R` and 3 other fields	High correlation
`AUXU3KR` is highly overall correlated with `AUXU2KR` and 3 other fields	High correlation
`AUXU4KR` is highly overall correlated with `AUXU2KR` and 3 other fields	High correlation
`AUXU6KR` is highly overall correlated with `AUXU3KR` and 2 other fields	High correlation
`AUXU8KR` is highly overall correlated with `AUXU3KR` and 2 other fields	High correlation

Reproduction

Analysis started	2023-04-10 09:21:59.416023
Analysis finished	2023-04-10 09:22:11.513346
Duration	12.1 seconds
Software version	pandas-profiling v3.6.6
Download configuration	config.json

SEQN
Real number (ℝ)

Distinct	3260
Distinct (%)	64.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49814.04

Minimum	57
Maximum	93689
Zeros	0
Zeros (%)	0.0%
Negative	0
Negative (%)	0.0%
Memory size	39.6 KiB

Quantile statistics

Minimum	57
5-th percentile	6123.7
Q1	31280.25
median	54141.5
Q3	67377.75
95-th percentile	90938.45
Maximum	93689
Range	93632
Interquartile range (IQR)	36097.5

Descriptive statistics

Standard deviation	26043.909
Coefficient of variation (CV)	0.52282267
Kurtosis	-0.96621407
Mean	49814.04
Median Absolute Deviation (MAD)	18691
Skewness	-0.061414081
Sum	2.5195942 × 10⁸
Variance	6.7828521 × 10⁸
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=50)

Value	Count	Frequency (%)
4120	2	< 0.1%
84615	2	< 0.1%
19916	2	< 0.1%
32202	2	< 0.1%
28100	2	< 0.1%
5571	2	< 0.1%
89538	2	< 0.1%
71103	2	< 0.1%
34233	2	< 0.1%
64946	2	< 0.1%
Other values (3250)	5038	99.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
57	1	< 0.1%
150	1	< 0.1%
162	2	< 0.1%
191	2	< 0.1%
193	1	< 0.1%
493	1	< 0.1%
505	1	< 0.1%
560	2	< 0.1%
570	1	< 0.1%
613	2	< 0.1%

Value	Count	Frequency (%)
93689	1	< 0.1%
93685	2	< 0.1%
93643	1	< 0.1%
93633	2	< 0.1%
93631	2	< 0.1%
93567	2	< 0.1%
93560	1	< 0.1%
93558	1	< 0.1%
93520	2	< 0.1%
93512	2	< 0.1%

AUXU500R
Real number (ℝ)

Distinct	23
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	30.948992

Minimum	0
Maximum	120
Zeros	11
Zeros (%)	0.2%
Negative	0
Negative (%)	0.0%
Memory size	39.6 KiB

Quantile statistics

Minimum	0
5-th percentile	10
Q1	20
median	30
Q3	40
95-th percentile	65
Maximum	120
Range	120
Interquartile range (IQR)	20

Descriptive statistics

Standard deviation	15.868782
Coefficient of variation (CV)	0.51273987
Kurtosis	1.9081383
Mean	30.948992
Median Absolute Deviation (MAD)	10
Skewness	1.1941796
Sum	156540
Variance	251.81824
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=23)

Value	Count	Frequency (%)
20	798	15.8%
25	785	15.5%
30	750	14.8%
15	538	10.6%
35	506	10.0%
40	390	7.7%
10	264	5.2%
45	251	5.0%
50	187	3.7%
55	138	2.7%
Other values (13)	451	8.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	11	0.2%
5	70	1.4%
10	264	5.2%
15	538	10.6%
20	798	15.8%
25	785	15.5%
30	750	14.8%
35	506	10.0%
40	390	7.7%
45	251	5.0%

Value	Count	Frequency (%)
120	1	< 0.1%
105	4	0.1%
100	7	0.1%
95	7	0.1%
90	11	0.2%
85	13	0.3%
80	24	0.5%
75	36	0.7%
70	77	1.5%
65	88	1.7%

AUXU1K1R
Real number (ℝ)

Distinct	24
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.558719

Minimum	0
Maximum	120
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	39.6 KiB

Quantile statistics

Minimum	0
5-th percentile	15
Q1	25
median	30
Q3	40
95-th percentile	65
Maximum	120
Range	120
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	15.22745
Coefficient of variation (CV)	0.4537554
Kurtosis	1.7990186
Mean	33.558719
Median Absolute Deviation (MAD)	10
Skewness	1.139477
Sum	169740
Variance	231.87523
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
25	854	16.9%
30	779	15.4%
35	676	13.4%
20	650	12.9%
40	453	9.0%
15	385	7.6%
45	310	6.1%
50	218	4.3%
55	174	3.4%
60	147	2.9%
Other values (14)	412	8.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
5	22	0.4%
10	118	2.3%
15	385	7.6%
20	650	12.9%
25	854	16.9%
30	779	15.4%
35	676	13.4%
40	453	9.0%
45	310	6.1%

Value	Count	Frequency (%)
120	2	< 0.1%
110	2	< 0.1%
105	1	< 0.1%
100	1	< 0.1%
95	9	0.2%
90	13	0.3%
85	16	0.3%
80	25	0.5%
75	46	0.9%
70	59	1.2%

AUXU1K2R
Real number (ℝ)

Distinct	24
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	33.407473

Minimum	0
Maximum	120
Zeros	1
Zeros (%)	< 0.1%
Negative	0
Negative (%)	0.0%
Memory size	39.6 KiB

Quantile statistics

Minimum	0
5-th percentile	15
Q1	25
median	30
Q3	40
95-th percentile	65
Maximum	120
Range	120
Interquartile range (IQR)	15

Descriptive statistics

Standard deviation	15.440901
Coefficient of variation (CV)	0.46219902
Kurtosis	1.7516126
Mean	33.407473
Median Absolute Deviation (MAD)	10
Skewness	1.1415488
Sum	168975
Variance	238.42144
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=24)

Value	Count	Frequency (%)
25	855	16.9%
30	801	15.8%
20	689	13.6%
35	617	12.2%
40	445	8.8%
15	361	7.1%
45	306	6.0%
50	218	4.3%
55	177	3.5%
60	135	2.7%
Other values (14)	454	9.0%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	1	< 0.1%
5	34	0.7%
10	134	2.6%
15	361	7.1%
20	689	13.6%
25	855	16.9%
30	801	15.8%
35	617	12.2%
40	445	8.8%
45	306	6.0%

Value	Count	Frequency (%)
120	2	< 0.1%
110	1	< 0.1%
105	1	< 0.1%
100	2	< 0.1%
95	12	0.2%
90	12	0.2%
85	15	0.3%
80	29	0.6%
75	46	0.9%
70	64	1.3%

AUXU2KR
Real number (ℝ)

Distinct	25
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	40.163108

Minimum	0
Maximum	120
Zeros	7
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	39.6 KiB

Quantile statistics

Minimum	0
5-th percentile	15
Q1	25
median	40
Q3	50
95-th percentile	75
Maximum	120
Range	120
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	18.165796
Coefficient of variation (CV)	0.45230055
Kurtosis	0.13168381
Mean	40.163108
Median Absolute Deviation (MAD)	15
Skewness	0.55798334
Sum	203145
Variance	329.99613
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
30	610	12.1%
35	573	11.3%
40	510	10.1%
25	479	9.5%
45	423	8.4%
20	384	7.6%
50	370	7.3%
55	354	7.0%
60	276	5.5%
15	275	5.4%
Other values (15)	804	15.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	7	0.1%
5	35	0.7%
10	141	2.8%
15	275	5.4%
20	384	7.6%
25	479	9.5%
30	610	12.1%
35	573	11.3%
40	510	10.1%
45	423	8.4%

Value	Count	Frequency (%)
120	1	< 0.1%
115	2	< 0.1%
110	2	< 0.1%
105	6	0.1%
100	12	0.2%
95	10	0.2%
90	16	0.3%
85	34	0.7%
80	71	1.4%
75	104	2.1%

AUXU3KR
Real number (ℝ)

Distinct	25
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	49.553183

Minimum	0
Maximum	120
Zeros	6
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	39.6 KiB

Quantile statistics

Minimum	0
5-th percentile	20
Q1	35
median	50
Q3	60
95-th percentile	80
Maximum	120
Range	120
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	18.907475
Coefficient of variation (CV)	0.38155925
Kurtosis	-0.15391916
Mean	49.553183
Median Absolute Deviation (MAD)	15
Skewness	0.17341492
Sum	250640
Variance	357.49262
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
55	548	10.8%
60	486	9.6%
50	468	9.3%
40	428	8.5%
45	425	8.4%
35	417	8.2%
65	403	8.0%
30	388	7.7%
70	311	6.1%
25	268	5.3%
Other values (15)	916	18.1%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	6	0.1%
5	16	0.3%
10	47	0.9%
15	131	2.6%
20	174	3.4%
25	268	5.3%
30	388	7.7%
35	417	8.2%
40	428	8.5%
45	425	8.4%

Value	Count	Frequency (%)
120	4	0.1%
115	5	0.1%
110	4	0.1%
105	8	0.2%
100	19	0.4%
95	34	0.7%
90	42	0.8%
85	89	1.8%
80	143	2.8%
75	194	3.8%

AUXU4KR
Real number (ℝ)

Distinct	26
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	56.600435

Minimum	-5
Maximum	120
Zeros	3
Zeros (%)	0.1%
Negative	1
Negative (%)	< 0.1%
Memory size	39.6 KiB

Quantile statistics

Minimum	-5
5-th percentile	25
Q1	45
median	55
Q3	70
95-th percentile	90
Maximum	120
Range	125
Interquartile range (IQR)	25

Descriptive statistics

Standard deviation	19.648229
Coefficient of variation (CV)	0.34713918
Kurtosis	-0.062642823
Mean	56.600435
Median Absolute Deviation (MAD)	15
Skewness	0.064240393
Sum	286285
Variance	386.05289
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=26)

Value	Count	Frequency (%)
65	543	10.7%
60	530	10.5%
55	524	10.4%
50	454	9.0%
70	408	8.1%
45	400	7.9%
40	334	6.6%
75	307	6.1%
35	269	5.3%
30	248	4.9%
Other values (16)	1041	20.6%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-5	1	< 0.1%
0	3	0.1%
5	8	0.2%
10	30	0.6%
15	68	1.3%
20	126	2.5%
25	115	2.3%
30	248	4.9%
35	269	5.3%
40	334	6.6%

Value	Count	Frequency (%)
120	9	0.2%
115	6	0.1%
110	16	0.3%
105	15	0.3%
100	67	1.3%
95	82	1.6%
90	125	2.5%
85	135	2.7%
80	235	4.6%
75	307	6.1%

AUXU6KR
Real number (ℝ)

Distinct	25
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	63.825623

Minimum	0
Maximum	120
Zeros	5
Zeros (%)	0.1%
Negative	0
Negative (%)	0.0%
Memory size	39.6 KiB

Quantile statistics

Minimum	0
5-th percentile	25
Q1	50
median	65
Q3	80
95-th percentile	100
Maximum	120
Range	120
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	21.49046
Coefficient of variation (CV)	0.33670584
Kurtosis	-0.26868382
Mean	63.825623
Median Absolute Deviation (MAD)	15
Skewness	-0.094310217
Sum	322830
Variance	461.83987
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
70	508	10.0%
65	487	9.6%
60	444	8.8%
75	430	8.5%
55	398	7.9%
80	378	7.5%
50	313	6.2%
85	284	5.6%
45	267	5.3%
40	237	4.7%
Other values (15)	1312	25.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
0	5	0.1%
5	8	0.2%
10	17	0.3%
15	40	0.8%
20	74	1.5%
25	133	2.6%
30	141	2.8%
35	225	4.4%
40	237	4.7%
45	267	5.3%

Value	Count	Frequency (%)
120	18	0.4%
115	31	0.6%
110	37	0.7%
105	80	1.6%
100	131	2.6%
95	163	3.2%
90	209	4.1%
85	284	5.6%
80	378	7.5%
75	430	8.5%

AUXU8KR
Real number (ℝ)

Distinct	25
Distinct (%)	0.5%
Missing	0
Missing (%)	0.0%
Infinite	0
Infinite (%)	0.0%
Mean	68.643733

Minimum	-10
Maximum	110
Zeros	3
Zeros (%)	0.1%
Negative	3
Negative (%)	0.1%
Memory size	39.6 KiB

Quantile statistics

Minimum	-10
5-th percentile	25
Q1	55
median	70
Q3	85
95-th percentile	100
Maximum	110
Range	120
Interquartile range (IQR)	30

Descriptive statistics

Standard deviation	22.190218
Coefficient of variation (CV)	0.32326648
Kurtosis	-0.21106669
Mean	68.643733
Median Absolute Deviation (MAD)	15
Skewness	-0.45467843
Sum	347200
Variance	492.40578
Monotonicity	Not monotonic

Histogram with fixed size bins (bins=25)

Value	Count	Frequency (%)
70	487	9.6%
75	461	9.1%
65	459	9.1%
80	424	8.4%
90	392	7.8%
85	389	7.7%
60	355	7.0%
55	286	5.7%
95	255	5.0%
50	241	4.8%
Other values (15)	1309	25.9%

Minimum 10 values
Maximum 10 values

Value	Count	Frequency (%)
-10	1	< 0.1%
-5	2	< 0.1%
0	3	0.1%
5	13	0.3%
10	16	0.3%
15	52	1.0%
20	79	1.6%
25	101	2.0%
30	114	2.3%
35	148	2.9%

Value	Count	Frequency (%)
110	103	2.0%
105	127	2.5%
100	198	3.9%
95	255	5.0%
90	392	7.8%
85	389	7.7%
80	424	8.4%
75	461	9.1%
70	487	9.6%
65	459	9.1%

Auto

Heatmap
Table

	SEQN	AUXU500R	AUXU1K1R	AUXU1K2R	AUXU2KR	AUXU3KR	AUXU4KR	AUXU6KR	AUXU8KR
SEQN	1.000	-0.031	0.057	0.057	-0.015	-0.027	-0.064	-0.066	-0.010
AUXU500R	-0.031	1.000	0.681	0.691	0.316	0.051	-0.052	0.026	0.066
AUXU1K1R	0.057	0.681	1.000	0.965	0.547	0.187	0.044	0.069	0.116
AUXU1K2R	0.057	0.691	0.965	1.000	0.553	0.191	0.049	0.075	0.119
AUXU2KR	-0.015	0.316	0.547	0.553	1.000	0.689	0.524	0.465	0.431
AUXU3KR	-0.027	0.051	0.187	0.191	0.689	1.000	0.853	0.706	0.592
AUXU4KR	-0.064	-0.052	0.044	0.049	0.524	0.853	1.000	0.803	0.669
AUXU6KR	-0.066	0.026	0.069	0.075	0.465	0.706	0.803	1.000	0.830
AUXU8KR	-0.010	0.066	0.116	0.119	0.431	0.592	0.669	0.830	1.000

Count
Matrix

A simple visualization of nullity by column.

Nullity matrix is a data-dense display which lets you quickly visually pick out patterns in data completion.

First rows
Last rows

	SEQN	AUXU500R	AUXU1K1R	AUXU1K2R	AUXU2KR	AUXU3KR	AUXU4KR	AUXU6KR	AUXU8KR
0	57	45	25	20	30	40	45	50	80
1	162	15	20	20	50	75	80	75	90
2	191	20	20	20	25	45	60	95	90
3	193	30	35	30	25	10	10	20	35
4	505	40	35	35	45	30	40	35	30
5	560	50	50	55	70	60	75	70	90
6	570	20	35	35	25	30	35	50	85
7	613	25	25	25	25	40	45	40	45
8	655	35	40	40	40	50	70	75	75
9	731	55	55	55	50	55	55	60	80

	SEQN	AUXU500R	AUXU1K1R	AUXU1K2R	AUXU2KR	AUXU3KR	AUXU4KR	AUXU6KR	AUXU8KR
5048	93364	25	35	30	30	40	45	60	60
5049	93454	15	20	20	45	70	75	80	90
5050	93498	25	35	35	35	55	50	35	30
5051	93512	30	40	40	35	40	35	20	25
5052	93520	20	20	20	40	75	75	80	80
5053	93558	25	20	20	30	30	55	70	95
5054	93567	50	25	25	15	20	25	20	20
5055	93631	30	30	30	40	45	55	60	55
5056	93633	35	40	40	35	50	35	35	50
5057	93685	15	15	15	35	55	90	90	105

Overview

Variables

Interactions

Correlations

Missing values

Sample

	SEQN	AUXU500R	AUXU1K1R	AUXU1K2R	AUXU2KR	AUXU3KR	AUXU4KR	AUXU6KR	AUXU8KR
0	57	45	25	20	30	40	45	50	80
1	162	15	20	20	50	75	80	75	90
2	191	20	20	20	25	45	60	95	90
3	193	30	35	30	25	10	10	20	35
4	505	40	35	35	45	30	40	35	30
5	560	50	50	55	70	60	75	70	90
6	570	20	35	35	25	30	35	50	85
7	613	25	25	25	25	40	45	40	45
8	655	35	40	40	40	50	70	75	75
9	731	55	55	55	50	55	55	60	80

	SEQN	AUXU500R	AUXU1K1R	AUXU1K2R	AUXU2KR	AUXU3KR	AUXU4KR	AUXU6KR	AUXU8KR
0	57	45	25	20	30	40	45	50	80
1	162	15	20	20	50	75	80	75	90
2	191	20	20	20	25	45	60	95	90
3	193	30	35	30	25	10	10	20	35
4	505	40	35	35	45	30	40	35	30
5	560	50	50	55	70	60	75	70	90
6	570	20	35	35	25	30	35	50	85
7	613	25	25	25	25	40	45	40	45
8	655	35	40	40	40	50	70	75	75
9	731	55	55	55	50	55	55	60	80

	SEQN	AUXU500R	AUXU1K1R	AUXU1K2R	AUXU2KR	AUXU3KR	AUXU4KR	AUXU6KR	AUXU8KR
0	57	45	25	20	30	40	45	50	80
1	162	15	20	20	50	75	80	75	90
2	191	20	20	20	25	45	60	95	90
3	193	30	35	30	25	10	10	20	35
4	505	40	35	35	45	30	40	35	30
5	560	50	50	55	70	60	75	70	90
6	570	20	35	35	25	30	35	50	85
7	613	25	25	25	25	40	45	40	45
8	655	35	40	40	40	50	70	75	75
9	731	55	55	55	50	55	55	60	80